Database Development (Comp11007)

The class notes is for learning material

Class material is used for learning

Where we will learn about the database relationship

This is a class note for learning material

Contents SQL CODE CREATE A TABLE INSERT DATA ADD COLUMN Increase size and add NULLS UPDATE ADD A FOREIGN KEY DELETE DATA DELETE MULTIPLE DATA ALTER DELETE A COLUMN COPY AN EXISTING TABLE Including records Excluding records Select the columns you want DROP TABLE SQL SELECT Function Retrieve all columns and rows Retrieve Some Columns, All Rows Retrieve Distinct Values Retrieve Calculated Values WHERE Clause to Filter Filter Rows (Comparison/Compound Search) Filter Rows (Rang...